To make certain fields visible only to specific groups or users, such as displaying the "Product Cost" field in a "Product" sheet only to the Accounting department, there are two ways to achieve this. Choose the option that best fits your needs below.
1. Field Level Access Rights: Set access for individual fields. For example, the "Sales" group can view and edit all records in the "Product" sheet, but the "Product Cost" field will be hidden based on access settings.
2. Multiple Versions: Create different versions of the same sheet to show or hide specific fields and customize the layout for each version. For instance, you can create one version of the "Product" sheet for the "Sales" group and another for the "Accounting" group.